﻿-- ================================================
-- Remarks: Not part of standard Stored Proc
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Ivy_SiteAdministration_Sys_ActivityMaster_GetAllByPrimaryKey')
	BEGIN
		DROP  Procedure  [Ivy_SiteAdministration_Sys_ActivityMaster_GetAllByPrimaryKey]
	END
GO

CREATE PROCEDURE [Ivy_SiteAdministration_Sys_ActivityMaster_GetAllByPrimaryKey]
-- =============================================
-- Author:		<Ram pravesh kr>
-- Create date: <1/10/2016>
-- Description:	<Ivy_SiteAdministration_Sys_ActivityMaster_GetAllByPrimaryKey>
-- =============================================

-- Add the parameters for the stored procedure here

	(
				@ActivityKey int
	) 
AS 
BEGIN 
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements. 
	SET NOCOUNT OFF; 

    SELECT 
			[ActivityKey], 
			[ActivityCode], 
			[ActivityName], 
			[ActivityDescription], 
			[ActivityTypeKey], 
			[ActivityTypeCode], 
			[ActivityTypeName], 

			[Sys_DateOfCreation], 
			[Sys_DateOfModification], 
			[Sys_CreatedByID], 
			[Sys_ModifiedByID], 
			[Sys_DeleteType], 
			[Sys_IsDeleted], 
			[Sys_OrganizationID], 
			[Sys_InitialPrimaryKeys], 
			[Sys_WorkstationName] 
    FROM 
			[Sys_ActivityMaster] 
    WHERE 
		( 
			[ActivityKey] = @ActivityKey
		); 

END 
GO 


-- =================================END=====================================

